workgroupmapper
Table: workgroupmapper
The workgroupmapper table maps users to workgroups and locations.
Columns
| Column Name | Data Type | Constraints | Description |
|---|---|---|---|
| mappedId | int(11) | NO | Primary key referencing ID mapper |
| workgrouptypeId | int(11) | NO | Reference to workgroup type |
| createdByUserId | int(11) | YES | User who created the mapping |
| lastEditedByUserId | int(11) | YES | User who last edited the mapping |
| createdDate | datetime | YES | Creation timestamp |
| lastEditedDate | datetime | YES | Last edited timestamp |
| locationId | int(11) | YES | Location ID assigned |
Indexes
workgroupId_fk_idx— Index onworkgrouptypeIdcreatedByU_fk_idx— Index oncreatedByUserIdeditedByU_fk_idx— Index onlastEditedByUserIdwgmapper_location_FK— Index onlocationId
Foreign Key Relations
mappedId → idmapper.mappedIdworkgrouptypeId → workgrouptype.workgrouptypeIdcreatedByUserId → user.mappedIdlastEditedByUserId → user.mappedIdlocationId → vaccinationcenter.mappedId
Usage Notes
- Maps users to workgroups and field locations.
- Ensures proper scheduling and resource allocation.